Name | Type | Length | IsNullable | Collation |
ProductID | int | 4 | ![]() | |
ProductName | nvarchar | 80 | ![]() | SQL_Latin1_General_CP1_CI_AS |
ProductName | sysname | 80 | ![]() | SQL_Latin1_General_CP1_CI_AS |
create view "Current Product List" AS
SELECT Product_List.ProductID, Product_List.ProductName
FROM Products AS Product_List
WHERE (((Product_List.Discontinued)=0))
--ORDER BY Product_List.ProductName